Supported data types
The following table shows the default mapping from Compose data types to Apache Hive and Databricks data types.
| Compose Data Types | Hive Data Types | Databricks Data Types |
|
INTEGER |
INT |
INT |
|
DATETIME |
TIMESTAMP |
TIMESTAMP |
|
TIME |
TIMESTAMP |
TIMESTAMP |
|
DATE |
DATE |
DATE |
|
BIGINT |
REAL |
BIGINT |
|
BYTE ARRAY |
STRING |
STRING |
|
DECIMAL |
DECIMAL (P,S) |
DECIMAL (P,S) |
|
GUID |
VARCHAR (38) |
STRING |
|
VARCHAR |
VARCHAR (LENGTH) |
VARCHAR (LENGTH) |
|
STRING |
STRING |
STRING |